主页 > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

AnswerBea (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

您必须登录，才能发布信息讨论。

类似词条

YourShow
软件; 生产力软件

A presentation software that empowers you to deliver more ...

Continum
软件; 操作系统

A novel feature soon to be seen in the latest version of ...

Evernote
软件; 生产力软件

Evernote is a simple glassware that makes taking notes easy ...

Dragon Dictation
软件; 手机软件

A speech recognition App developed by Nuance Communications ...

ActionScript
软件; 图形设计软件

ActionScript is the scripting language used to control ...

case-sensitive
软件; 软件工程

Computer command which specifies that each letter of a word ...

创建者

精选词汇表

Video Games Genres

类别： 娱乐   1 1 词条

Hiking Trip

类别： 体育   1 6 词条

Photograpy Framing

类别： 艺术   1 55 词条

Azazeel

类别： 文学   1 3 词条

Futures Terms and Definitions

类别： 商业   2 20 词条

Table Tennis Ball

类别： 体育   1 5 词条

TermWiki is ranked top innovative application by IDC.

© 2025 CSOFT International, Ltd.       京ICP备12032581号-1

关注我们：